package com.peace.hospital.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.peace.hospital.entity.hospitalization.entity.Staffandpatient;
import org.apache.ibatis.annotations.Mapper;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author xie
 * @since 2019-11-20
 */
@Mapper
public interface StaffandpatientMapper extends BaseMapper<Staffandpatient> {
//
//    @Insert("INSERT INTO staffandpatient" +
//            "VALUES(#{i.inpid},#{s.staid})")
//    Integer insertInner(Integer s, InpatientmessageDto i);
//
//
//    @Select({
//            "SELECT s.staid,staname" +
//                    "FROM hospitalization.staffinfo s INNER JOIN hospitalization.staffandpatient st ON s.staid = st.staid" +
//                    "INNER JOIN hospitalization.workersandemployeeinformation w ON s.staid = w.staid" +
//                    "WHERE inpid = #{inpid} GROUP BY s.staid ORDER BY posid"
//    })
//    Staffinfo getStaff(Integer inpid);
}
